Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MeasurementID (PK) | Token ID for a Measurement instance. | ID_MSRMT | Identity | integer | |
MeasurementName | Business name assigned to a Measurement. | NM_MSRMT | DescriptionShort | varchar(255) | |
MeasurementTypeCode (FK) | Indicates the category of measurement represented by this MeasurementType instance. Valid values include: VOLUME = number of units or a count FREQUENCY = number of occurences in a time period MAGNITUDE = relative size of each unit | CD_MSRMT_TYP | Code | varchar(20) | MeasurementType(LU_MSRMT_TYP) |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |